。Spreadsheet Operations

Powerful spreadsheets may be used to view, sort and edit the input data and results. The spreadsheets and model views are synchronized, unless you turn this feature off in the Application Settings on the Tools Menu. As you edit a model graphically the spreadsheets are automatically updated and as you make changes in the spreadsheets the model views reflect these changes immediately.

 

The input data may be accessed from the Spreadsheets Menu. You may edit the data or you can add new data. You can also paste data from another application directly into the spreadsheet via the Windows clipboard. Any changes made to the input spreadsheets may also be viewed graphically.

After solving the model, results are recorded in spreadsheets for browsing. These spreadsheets may be accessed from the Results Menu You may sort the results in order to find maximums and exclude data that is not important. You may also copy this data to the Windows clipboard and use it in another application.

For additional advice on this topic, please see the RISA Tips & Tricks webpage at risa.com/post/support. Type in Search keywords: Advanced Spreadsheet.

What do you want to do?
What do you want to know?

Moving and Scrolling

To move between cells in a spreadsheet, click any cell or use the keyboard arrow keys. When you move to a cell it becomes the active cell. To see a different area of the spreadsheet use the vertical scroll bars on the right side of the spreadsheet.

To Scroll Do This

One row up or down

Click the arrows on the vertical scroll bar.

One column left or right

Click the arrows on the horizontal scroll bar.

One page up or down

Click above or below the scroll box in the vertical scroll bar.

One page left or right

Click to the left or right of the scroll box in the horizontal scroll bar.

A large distance

Drag the scroll box to the approximate relative position.

Note:

Spreadsheet Keyboard Commands

The following keyboard commands are available:

Key Function

Arrow Keys

Move the active cell one location

TAB

Move right one cell

ENTER

Move to the first column of the next line.

Adds new line if necessary.

PAGE UP

Move the active cell one full page up.

PAGE DOWN

Move the active cell one full page down.

HOME

Move to the first line of the spreadsheet.

END

Move to the last line of the spreadsheet.

F3

Insert new line below current line.

F4

Delete current line.

F8

Insert new line below current line and repeat the current values in the new line.

Selecting Spreadsheet Cells

Before you can carry out commands or tasks in a spreadsheet, you must select the cells that you want to work with.

To Select Do This

A single cell

Click the cell, or press the arrow keys to move to the cell.

A range of cells

Click the first cell of the range, and then drag to the last cell.

An entire row

Click the row heading.

An entire column

Click the column heading.

Adjacent rows or columns

Drag across the row or column headings

Note:

Undoing Operations

RISAFloor provides you with virtually unlimited Undo capability so that you may easily correct mistakes or just back up to try different possibilities. Simply click the Undo button  as many times as you wish to go back a step. The model view and the spreadsheets will visually display the "undoing". Remember that graphic edits are undone as well.

Redoing Operations

RISAFloor provides you with virtually unlimited Redo capability so that you may reapply actions that were previously undone. Simply click the Redo button  as many times as the Undo button was used just prior. The model view and the spreadsheets will visually display the "redoing". Remember that graphic edits are redone as well.

Editing Spreadsheets

The spreadsheets have been specifically developed for the input and editing of structural models. There are many ways to edit the spreadsheets allowing you to quickly build your model. You may copy and move data from other locations or other files. You may also fill large blocks of cells automatically and perform math on these cells.

To Fill Selected Cells

  1. Select the cells you wish to fill.
  2. Click the Block Fill  button.
  3. Type the value you wish to apply.
  4. Click OK.

To Perform Math on Selected Cells

  1. Select the desired cells.
  2. Click the Block Math  button.

  3. Specify the value and the operation you wish to apply.

  4. Click OK.

To Cancel or Undo Editing

To Edit Cell Contents

  1. Click the cell that contains the data you want to edit.
  2. Make any changes to the cell contents.
  3. To enter your changes, press ENTER.
  4. To cancel your changes, press ESC.

Note

Inserting, Deleting and Clearing Cells

To insert cells you must insert an entire row. When you delete cells you must delete an entire row. The row is removed from the worksheet and shifts the lower cells to fill the space. When you clear cells, you remove the cell contents but leave the blank cells on the spreadsheet.

To Insert Rows

  1. Click a cell in the row immediately above where you want the new row.
  2. To insert a blank line, click the Insert New Line  button.

  3. To have the values of the current line copied in the new line, click the Repeat Current Line   button.

To Clear Cell Contents

  1. Select the cells, rows, or columns you want to clear and press the DELETE key.

To Delete Rows

  1. Select the rows you want to delete.
  2. Click the Delete Marked Lines  button and the lower cells will shift up to fill the space.

Note

Moving and Copying Cell Contents

Standard Windows cut, copy and paste functions are fully supported. By using the clipboard you may move or copy any spreadsheet data to another location in the same spreadsheet, or to another spreadsheet (provided it fits). You may also copy data to or from another model or any other application that supports copy and paste such as a word processor or spreadsheet.

To Move or Copy Cells

  1. Select the cells you want to move or copy.
  2. To copy the cells select Copy on the Edit Menu.

To move cells select Cut on the Edit Menu.

  1. Click on the cell you wish to place the data in and click the Paste  button.

To Move or Copy Cells between Existing Cells

  1. Select the cells you want to move or copy.
  2. To copy the cells selectCopy on the Edit Menu.

To move cells select Cut on the Edit Menu.

  1. Select a cell on the row above where you want to place the data.
  2. Click the Insert New Line button for each new line that is needed.

  3. Click on the upper left cell you wish to place the data in and click the Paste  button.

To Move or Copy Cells to Another File

  1. Select the cells you want to move or copy.
  2. To copy the cells selectCopy on the Edit Menu.

To move cells select Cut on the Edit Menu.

  1. Open the file you wish to copy the data to.
  2. Click on the cell you wish to place the data in and click the Paste  button.

Note:

Finding in Spreadsheets

To locate or find a specific point or member while in a spreadsheet, click the Find  button on the Window Toolbar.

Sorting is not yet available in RISAFloor spreadsheets.

Default Spreadsheet Data

Many of the spreadsheets provide the option to save the current data as the default and every new file subsequent to the save will already have that data. This way the office standards that you might use in most of your models are already entered and available in new models. This feature is available in the following spreadsheets: Materials, Design Rules,Deck Definitions, Area Load Definitions, Footings, and Load Combinations.

To save default data simply click the Save as Defaults  button when you are ready and the current data in the spreadsheet will be used in each new file that you create. The data is saved for the current, active, spreadsheet only and affects no other open or closed spreadsheets.

Export to Excel Spreadsheet

For all Results spreadsheet, the program is capable of exporting them into Excel Spreadsheet.

The process is as follows:

  1. Right Click and click Export to Excel option.
  2. Choose if you want to export the current spreadsheet tab or all tabs.
  3. Select Excel file name and file save location and export.

Note: The Export to Excel can also be used by clicking the button on ribbon .

Special Spreadsheet Functions

There are special functions that help you with a particular spreadsheet.

Load Combinations Spreadsheet

You may click button to have the program generate load combinations based on a variety of Building Codes. See Generating Building Code Combinations for more information.

Selecting Items in the Model View

In certain results spreadsheets there is the capability to have elements selected graphically.

The process is as follows:

  1. Unselect the entire model.
  2. Open the desired results spreadsheet.
  3. Highlight in Yellow the lines you wish to view graphically, by clicking on the number of those lines on the far left.
  4. Click the Select Marked Lines in Current View icon .
  5. Only those elements highlighted will be selected graphically.

Note: The inverse process can be used to Unselect Marked Lines using the .